# @Time : 2021/9/17 12:36
# @Author : Li Kunlun
# @Description : 综测表分数排序
import pandas as pd

students = pd.read_excel("dataset/核对版 综测表 信研2003.xlsx", header=4, index_col=None)

print(students.shape)
print(students.columns)

row_sum = students[['score1', 'score2', 'score3', 'score4', 'score5']].sum(axis=1)
students[['score_sum']] = row_sum
print(row_sum)
